Google BigQuery Data Source

Please enter the following parameters to connect to a Google BigQuery data source:

• Alias: name of the data source to be used in CData Virtuality Server
• Project number: the number of the Project created in Google Developer's Console
• User name: user name associated with BigQuery Project
• User key file path: the path to the certificate (*.p12) that is pre-installed in the CData Virtuality Server
• Temporary tables dataset: optional property that specifies a dataset id for temporary tables to create. Should be defined to support large results when 'transform queries' option is disabled.
• Transform query: enabled the feature that rewrites incoming queries according to the BigQuery syntax.
• Large results: controls whether large results will be retrieved from data source.
• Data source parameters: additional connection parameters
• Translator parameters: additional translator parameters

Below are some examples of the most common data source parameters, see the reference manual for the full list:

• importer.useFullSchemaName=TRUE - schema names will be prefixed to table names to avoid duplicates
• importer.importProcedures=TRUE - stored procedures will be imported
• importer.useProcedureSpecificName=TRUE - when two stored procedures being imported have identical names, an index will be appended to their names in order to avoid conflicts

To test the connection parameters press the Test connection button.